﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.Security;
using Oracle.DataAccess.Client;
using System.Configuration;

namespace WebApplication
{
    public partial class SiteMaster : System.Web.UI.MasterPage
    {
        OracleConnection conn;
        OracleCommand command;
        OracleDataReader reader;

        protected void Page_Load(object sender, EventArgs e)
        {
            //als user ingelogd is, kan hij bij de reserveer pagina
            if(Request.IsAuthenticated == true){
                NavigationMenu.Items[1].NavigateUrl = "~/Reserveren.aspx";
            }

            List<String> list = new List<String>();            
            string s = "SELECT RFID FROM KLANT_BETALEND ";

            conn = new OracleConnection();

            conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["OracleConnectionString"].ToString();
            command = new OracleCommand(s, conn);

            conn.Open();
         
            reader = command.ExecuteReader();
           
            

            while(reader.Read()){
                for (int i = 0; i < reader.FieldCount; i++)
                {
                    list.Add(reader.GetValue(i).ToString());
                }
            }

            conn.Close();

            

        }
    }
}
